Notes/Domino 6 and 7 Forum : RE: Unique Field Lookup Issue

Notes/Domino 6 and 7 Forum

RE: Unique Field Lookup Issue

RE: Unique Field Lookup Issue
Posted by ~Yentl Cisnitergon on 13.Jan.04 at 08:40 PM using a Web browser
Category: Domino Designer

Release: All Releases

Platform: All Platforms

Try like this:

look := @DbLookup("":"NoCache"; "" : "" ; "All Reqs"; RequestNo; "RequestNo");

@If(RequestNo = ""; @Failure("You have to enter a Req Number");
@IsError(look); @Success;
@elements(look) = 1 & !@IsNewDoc; @Success;
@Failure("This Req Number Already Exists."))

I think this'll cover you.

hth

Dana